Product Sales Project

Table of Contents

1. Importing Libraries/Datasets & Combining/Observing the Dataframe

2. Modifying the Dataframe

3. Exploratory Data Analysis/Visualization

4. Isolating Order IDs with Multiple Product Items

5. Creating Product IDs and Product Pair IDs for Unique Product Values

1. Importing Libraries/Datasets & Combining/Observing the Dataframe

1a. Importing Libraries/Datasets

1b. Combining the Monthly Dataframes into single Yearly Dataframe

2. Modifying the Dataframe

2a. Creating a Customer ID column

The Customer ID column will be created using the unique values of the Purchase Address as I will assume that each unique address is one unique customer.

Note: Order ID was not used to create Customer ID as each customer could order multiple products accross the year resulting in false Customer IDs

2b. Changing the Column Names in the Dataframe

2c. Creating an Order Total Column

2d. Splitting the Purchase Address in the Dataframe

2e. Splitting the Order Date column in the Dataframe

2f. Changing the column order in the Dataframe

3. Exploratory Data Analysis/Visualization

3a. Monthly Sales Totals/Monthly Product Sales

3b. Yearly Sales Totals by State (with City Breakdown)

3c. Monthly Sales by State

3d. Total Number of Products Ordered per Month/Total Count of Products Ordered in 2019

3e. Total Monthly Orders/Total Monthly Orders (by State)

4. Isolating Order IDs with Multiple Product Items

4a. Finding Rows with Duplicate Order IDs

4b. Grouping Products/Quantities Ordered/Order Totals together based on Order IDs

4c. Changing the column order in the Dataframe

4d. Cleaning the Multiple Items Dataframe (Drop Duplicates/Drop Columns)

4e. Creating a Dataframe to show Unique Products Pairs with Counts and Totals

i. Quick Data Check

4f. Visualizing Top 10 Paired Products

5. Creating Product IDs and Product Pair IDs for Unique Product Values

5a. Creating a Product ID and Product Pair ID column

5b. Changing the column order in the Dataframe